Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 1272 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 129.3 KiB |
| Average record size in memory | 104.1 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 1 |
gpu_memory_usage has constant value "2296381440.0" | Constant |
gpu_load has constant value "100.0" | Constant |
unpaid has constant value "0" | Constant |
reported_hashrate has constant value "3200000.0" | Constant |
df_index is highly correlated with relative_hour | High correlation |
relative_hour is highly correlated with df_index | High correlation |
df_index is uniformly distributed | Uniform |
relative_hour is uniformly distributed | Uniform |
df_index has unique values | Unique |
ts has unique values | Unique |
relative_hour has unique values | Unique |
hashrate has 174 (13.7%) zeros | Zeros |
unpaid has 1272 (100.0%) zeros | Zeros |
Reproduction
| Analysis started | 2021-12-01 03:31:54.405834 |
|---|---|
| Analysis finished | 2021-12-01 03:32:13.002826 |
| Duration | 18.6 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 1272 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 820.5 |
| Minimum | 185 |
|---|---|
| Maximum | 1456 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 185 |
|---|---|
| 5-th percentile | 248.55 |
| Q1 | 502.75 |
| median | 820.5 |
| Q3 | 1138.25 |
| 95-th percentile | 1392.45 |
| Maximum | 1456 |
| Range | 1271 |
| Interquartile range (IQR) | 635.5 |
Descriptive statistics
| Standard deviation | 367.3390804 |
|---|---|
| Coefficient of variation (CV) | 0.4477014996 |
| Kurtosis | -1.2 |
| Mean | 820.5 |
| Median Absolute Deviation (MAD) | 318 |
| Skewness | 0 |
| Sum | 1043676 |
| Variance | 134938 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 185 | 1 | 0.1% |
| 1030 | 1 | 0.1% |
| 1037 | 1 | 0.1% |
| 1036 | 1 | 0.1% |
| 1035 | 1 | 0.1% |
| 1034 | 1 | 0.1% |
| 1033 | 1 | 0.1% |
| 1032 | 1 | 0.1% |
| 1031 | 1 | 0.1% |
| 1029 | 1 | 0.1% |
| Other values (1262) | 1262 |
| Value | Count | Frequency (%) |
| 185 | 1 | |
| 186 | 1 | |
| 187 | 1 | |
| 188 | 1 | |
| 189 | 1 |
| Value | Count | Frequency (%) |
| 1456 | 1 | |
| 1455 | 1 | |
| 1454 | 1 | |
| 1453 | 1 | |
| 1452 | 1 |
| Distinct | 1272 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 KiB |
| Minimum | 2021-11-11 09:12:54-05:00 |
|---|---|
| Maximum | 2021-11-11 12:53:28-05:00 |
Histogram with fixed size bins (bins=50)
cpu_load
Real number (ℝ≥0)
| Distinct | 32 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3483490566 |
| Minimum | 0.1 |
|---|---|
| Maximum | 16.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.2 |
| Q1 | 0.2 |
| median | 0.2 |
| Q3 | 0.3 |
| 95-th percentile | 0.6 |
| Maximum | 16.2 |
| Range | 16.1 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.7922800871 |
|---|---|
| Coefficient of variation (CV) | 2.274385626 |
| Kurtosis | 247.4167372 |
| Mean | 0.3483490566 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 14.3285248 |
| Sum | 443.1 |
| Variance | 0.6277077364 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=32)
| Value | Count | Frequency (%) |
| 0.2 | 606 | |
| 0.3 | 471 | |
| 0.4 | 59 | 4.6% |
| 0.1 | 41 | 3.2% |
| 0.5 | 23 | 1.8% |
| 0.6 | 18 | 1.4% |
| 0.7 | 14 | 1.1% |
| 0.8 | 5 | 0.4% |
| 1 | 4 | 0.3% |
| 1.2 | 4 | 0.3% |
| Other values (22) | 27 | 2.1% |
| Value | Count | Frequency (%) |
| 0.1 | 41 | 3.2% |
| 0.2 | 606 | |
| 0.3 | 471 | |
| 0.4 | 59 | 4.6% |
| 0.5 | 23 | 1.8% |
| Value | Count | Frequency (%) |
| 16.2 | 1 | |
| 15.3 | 1 | |
| 9.4 | 1 | |
| 7.2 | 1 | |
| 5.7 | 1 |
cpu_freq
Real number (ℝ≥0)
| Distinct | 1236 |
|---|---|
| Distinct (%) | 97.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 957.9095833 |
| Minimum | 802.77 |
|---|---|
| Maximum | 3670.62 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 802.77 |
|---|---|
| 5-th percentile | 821.9075 |
| Q1 | 852.0825 |
| median | 887.985 |
| Q3 | 942.86 |
| 95-th percentile | 1211.4565 |
| Maximum | 3670.62 |
| Range | 2867.85 |
| Interquartile range (IQR) | 90.7775 |
Descriptive statistics
| Standard deviation | 301.0303938 |
|---|---|
| Coefficient of variation (CV) | 0.3142576283 |
| Kurtosis | 43.36028687 |
| Mean | 957.9095833 |
| Median Absolute Deviation (MAD) | 41.255 |
| Skewness | 6.091893073 |
| Sum | 1218460.99 |
| Variance | 90619.298 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 851.03 | 2 | 0.2% |
| 870.57 | 2 | 0.2% |
| 857.46 | 2 | 0.2% |
| 998.39 | 2 | 0.2% |
| 1002.15 | 2 | 0.2% |
| 867.81 | 2 | 0.2% |
| 867.22 | 2 | 0.2% |
| 1097.89 | 2 | 0.2% |
| 882.99 | 2 | 0.2% |
| 861.29 | 2 | 0.2% |
| Other values (1226) | 1252 |
| Value | Count | Frequency (%) |
| 802.77 | 1 | |
| 806.14 | 1 | |
| 807.9 | 1 | |
| 808.22 | 1 | |
| 808.27 | 1 |
| Value | Count | Frequency (%) |
| 3670.62 | 1 | |
| 3646.42 | 1 | |
| 3643.49 | 1 | |
| 3593.78 | 1 | |
| 3593.56 | 1 |
memory_usage
Real number (ℝ≥0)
| Distinct | 1124 |
|---|---|
| Distinct (%) | 88.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1861350902 |
| Minimum | 1448673280 |
|---|---|
| Maximum | 2159689728 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 1448673280 |
|---|---|
| 5-th percentile | 1453471130 |
| Q1 | 1968330752 |
| median | 1980700672 |
| Q3 | 1985700864 |
| 95-th percentile | 1988671898 |
| Maximum | 2159689728 |
| Range | 711016448 |
| Interquartile range (IQR) | 17370112 |
Descriptive statistics
| Standard deviation | 220150494.5 |
|---|---|
| Coefficient of variation (CV) | 0.1182745791 |
| Kurtosis | -0.2974227838 |
| Mean | 1861350902 |
| Median Absolute Deviation (MAD) | 6105088 |
| Skewness | -1.294418044 |
| Sum | 2.367638348 × 1012 |
| Variance | 4.846624023 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1976836096 | 3 | 0.2% |
| 1456304128 | 3 | 0.2% |
| 1986654208 | 3 | 0.2% |
| 1985888256 | 3 | 0.2% |
| 1456074752 | 3 | 0.2% |
| 1456553984 | 3 | 0.2% |
| 1455333376 | 3 | 0.2% |
| 1986883584 | 3 | 0.2% |
| 1979363328 | 3 | 0.2% |
| 1987391488 | 2 | 0.2% |
| Other values (1114) | 1243 |
| Value | Count | Frequency (%) |
| 1448673280 | 1 | |
| 1448804352 | 1 | |
| 1448996864 | 1 | |
| 1449136128 | 1 | |
| 1449201664 | 1 |
| Value | Count | Frequency (%) |
| 2159689728 | 1 | |
| 2080055296 | 1 | |
| 2076422144 | 1 | |
| 2026557440 | 1 | |
| 1998290944 | 1 |
cpu_temp
Real number (ℝ≥0)
| Distinct | 14 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.24292453 |
| Minimum | 26 |
|---|---|
| Maximum | 43 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 26 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 32 |
| median | 32 |
| Q3 | 33 |
| 95-th percentile | 34 |
| Maximum | 43 |
| Range | 17 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.219412971 |
|---|---|
| Coefficient of variation (CV) | 0.03781955232 |
| Kurtosis | 9.627640412 |
| Mean | 32.24292453 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.7694822866 |
| Sum | 41013 |
| Variance | 1.486967994 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 32 | 537 | |
| 33 | 447 | |
| 31 | 127 | 10.0% |
| 34 | 78 | 6.1% |
| 30 | 30 | 2.4% |
| 29 | 17 | 1.3% |
| 27 | 11 | 0.9% |
| 28 | 9 | 0.7% |
| 35 | 9 | 0.7% |
| 26 | 3 | 0.2% |
| Other values (4) | 4 | 0.3% |
| Value | Count | Frequency (%) |
| 26 | 3 | 0.2% |
| 27 | 11 | 0.9% |
| 28 | 9 | 0.7% |
| 29 | 17 | |
| 30 | 30 |
| Value | Count | Frequency (%) |
| 43 | 1 | 0.1% |
| 38 | 1 | 0.1% |
| 37 | 1 | 0.1% |
| 36 | 1 | 0.1% |
| 35 | 9 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2296381440 |
| Minimum | 2296381440 |
|---|---|
| Maximum | 2296381440 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 2296381440 |
|---|---|
| 5-th percentile | 2296381440 |
| Q1 | 2296381440 |
| median | 2296381440 |
| Q3 | 2296381440 |
| 95-th percentile | 2296381440 |
| Maximum | 2296381440 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | 0 |
| Kurtosis | 0 |
| Mean | 2296381440 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 2.920997192 × 1012 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 2296381440 | 1272 |
| Value | Count | Frequency (%) |
| 2296381440 | 1272 |
| Value | Count | Frequency (%) |
| 2296381440 | 1272 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100 |
| Minimum | 100 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 100 |
| Q1 | 100 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | 0 |
| Kurtosis | 0 |
| Mean | 100 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 127200 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 100 | 1272 |
| Value | Count | Frequency (%) |
| 100 | 1272 |
| Value | Count | Frequency (%) |
| 100 | 1272 |
gpu_temp
Real number (ℝ≥0)
| Distinct | 39 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 65.25471698 |
| Minimum | 36 |
|---|---|
| Maximum | 78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 36 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 63 |
| median | 65 |
| Q3 | 67 |
| 95-th percentile | 71 |
| Maximum | 78 |
| Range | 42 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.655231499 |
|---|---|
| Coefficient of variation (CV) | 0.05601482418 |
| Kurtosis | 11.73859349 |
| Mean | 65.25471698 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -1.45419031 |
| Sum | 83004 |
| Variance | 13.36071731 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=39)
| Value | Count | Frequency (%) |
| 64 | 271 | |
| 63 | 246 | |
| 65 | 183 | |
| 66 | 128 | |
| 67 | 109 | |
| 68 | 67 | 5.3% |
| 69 | 50 | 3.9% |
| 71 | 42 | 3.3% |
| 62 | 41 | 3.2% |
| 70 | 39 | 3.1% |
| Other values (29) | 96 | 7.5% |
| Value | Count | Frequency (%) |
| 36 | 1 | |
| 41 | 1 | |
| 42 | 2 | |
| 43 | 1 | |
| 44 | 1 |
| Value | Count | Frequency (%) |
| 78 | 1 | 0.1% |
| 77 | 2 | 0.2% |
| 76 | 2 | 0.2% |
| 75 | 8 | |
| 74 | 11 |
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2269392.031 |
| Minimum | 0 |
|---|---|
| Maximum | 4444444.44 |
| Zeros | 174 |
| Zeros (%) | 13.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2222222.22 |
| median | 2222222.22 |
| Q3 | 3333333.33 |
| 95-th percentile | 3333333.33 |
| Maximum | 4444444.44 |
| Range | 4444444.44 |
| Interquartile range (IQR) | 1111111.11 |
Descriptive statistics
| Standard deviation | 1184198.014 |
|---|---|
| Coefficient of variation (CV) | 0.5218128897 |
| Kurtosis | -0.3256136988 |
| Mean | 2269392.031 |
| Median Absolute Deviation (MAD) | 1111111.11 |
| Skewness | -0.5298384219 |
| Sum | 2886666664 |
| Variance | 1.402324935 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=5)
| Value | Count | Frequency (%) |
| 2222222.22 | 528 | |
| 3333333.33 | 396 | |
| 0 | 174 | 13.7% |
| 1111111.11 | 114 | 9.0% |
| 4444444.44 | 60 | 4.7% |
| Value | Count | Frequency (%) |
| 0 | 174 | 13.7% |
| 1111111.11 | 114 | 9.0% |
| 2222222.22 | 528 | |
| 3333333.33 | 396 | |
| 4444444.44 | 60 | 4.7% |
| Value | Count | Frequency (%) |
| 4444444.44 | 60 | 4.7% |
| 3333333.33 | 396 | |
| 2222222.22 | 528 | |
| 1111111.11 | 114 | 9.0% |
| 0 | 174 | 13.7% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0 |
| Minimum | 0 |
|---|---|
| Maximum | 0 |
| Zeros | 1272 |
| Zeros (%) | 100.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | 0 |
| Mean | 0 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 0 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 0 | 1272 |
| Value | Count | Frequency (%) |
| 0 | 1272 |
| Value | Count | Frequency (%) |
| 0 | 1272 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3200000 |
| Minimum | 3200000 |
|---|---|
| Maximum | 3200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 3200000 |
|---|---|
| 5-th percentile | 3200000 |
| Q1 | 3200000 |
| median | 3200000 |
| Q3 | 3200000 |
| 95-th percentile | 3200000 |
| Maximum | 3200000 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | 0 |
| Kurtosis | 0 |
| Mean | 3200000 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 4070400000 |
| Variance | 0 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=1)
| Value | Count | Frequency (%) |
| 3200000 | 1272 |
| Value | Count | Frequency (%) |
| 3200000 | 1272 |
| Value | Count | Frequency (%) |
| 3200000 | 1272 |
| Distinct | 1272 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.374694051 |
| Minimum | 0.5355555556 |
|---|---|
| Maximum | 4.211666667 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 10.1 KiB |
Quantile statistics
| Minimum | 0.5355555556 |
|---|---|
| 5-th percentile | 0.7195833333 |
| Q1 | 1.455694444 |
| median | 2.375138889 |
| Q3 | 3.294097222 |
| 95-th percentile | 4.028194444 |
| Maximum | 4.211666667 |
| Range | 3.676111111 |
| Interquartile range (IQR) | 1.838402778 |
Descriptive statistics
| Standard deviation | 1.062526675 |
|---|---|
| Coefficient of variation (CV) | 0.4474372919 |
| Kurtosis | -1.200170445 |
| Mean | 2.374694051 |
| Median Absolute Deviation (MAD) | 0.92 |
| Skewness | -0.001265427289 |
| Sum | 3020.610833 |
| Variance | 1.128962936 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5355555556 | 1 | 0.1% |
| 2.981111111 | 1 | 0.1% |
| 3.001388889 | 1 | 0.1% |
| 2.998611111 | 1 | 0.1% |
| 2.995833333 | 1 | 0.1% |
| 2.992777778 | 1 | 0.1% |
| 2.99 | 1 | 0.1% |
| 2.986944444 | 1 | 0.1% |
| 2.984166667 | 1 | 0.1% |
| 2.978333333 | 1 | 0.1% |
| Other values (1262) | 1262 |
| Value | Count | Frequency (%) |
| 0.5355555556 | 1 | |
| 0.5383333333 | 1 | |
| 0.5413888889 | 1 | |
| 0.5441666667 | 1 | |
| 0.5469444444 | 1 |
| Value | Count | Frequency (%) |
| 4.211666667 | 1 | |
| 4.208888889 | 1 | |
| 4.205833333 | 1 | |
| 4.203055556 | 1 | |
| 4.2 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 185 | 2021-11-11 09:12:54-05:00 | 1.0 | 886.36 | 1452724224 | 26.0 | 2.296381e+09 | 100.0 | 36.0 | 2222222.22 | 0 | 3200000.0 | 0.535556 |
| 1 | 186 | 2021-11-11 09:13:04-05:00 | 0.2 | 814.37 | 1453391872 | 27.0 | 2.296381e+09 | 100.0 | 42.0 | 2222222.22 | 0 | 3200000.0 | 0.538333 |
| 2 | 187 | 2021-11-11 09:13:15-05:00 | 0.3 | 825.45 | 1453432832 | 26.0 | 2.296381e+09 | 100.0 | 41.0 | 2222222.22 | 0 | 3200000.0 | 0.541389 |
| 3 | 188 | 2021-11-11 09:13:25-05:00 | 0.2 | 871.46 | 1453932544 | 26.0 | 2.296381e+09 | 100.0 | 42.0 | 2222222.22 | 0 | 3200000.0 | 0.544167 |
| 4 | 189 | 2021-11-11 09:13:35-05:00 | 0.2 | 1104.16 | 1453502464 | 27.0 | 2.296381e+09 | 100.0 | 43.0 | 2222222.22 | 0 | 3200000.0 | 0.546944 |
| 5 | 190 | 2021-11-11 09:13:46-05:00 | 0.1 | 1097.97 | 1452933120 | 27.0 | 2.296381e+09 | 100.0 | 44.0 | 2222222.22 | 0 | 3200000.0 | 0.550000 |
| 6 | 191 | 2021-11-11 09:13:56-05:00 | 0.3 | 848.67 | 1454145536 | 27.0 | 2.296381e+09 | 100.0 | 45.0 | 2222222.22 | 0 | 3200000.0 | 0.552778 |
| 7 | 192 | 2021-11-11 09:14:07-05:00 | 0.3 | 834.09 | 1452187648 | 27.0 | 2.296381e+09 | 100.0 | 46.0 | 2222222.22 | 0 | 3200000.0 | 0.555833 |
| 8 | 193 | 2021-11-11 09:14:17-05:00 | 0.2 | 842.17 | 1452937216 | 27.0 | 2.296381e+09 | 100.0 | 47.0 | 2222222.22 | 0 | 3200000.0 | 0.558611 |
| 9 | 194 | 2021-11-11 09:14:28-05:00 | 0.2 | 835.82 | 1453088768 | 27.0 | 2.296381e+09 | 100.0 | 48.0 | 2222222.22 | 0 | 3200000.0 | 0.561667 |
Last rows
| df_index | ts | cpu_load | cpu_freq | memory_usage | cpu_temp | gpu_memory_usage | gpu_load | gpu_temp | hashrate | unpaid | reported_hashrate | relative_hour | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1262 | 1447 | 2021-11-11 12:51:54-05:00 | 0.2 | 914.90 | 1986576384 | 33.0 | 2.296381e+09 | 100.0 | 64.0 | 2222222.22 | 0 | 3200000.0 | 4.185556 |
| 1263 | 1448 | 2021-11-11 12:52:05-05:00 | 0.3 | 851.76 | 1987608576 | 33.0 | 2.296381e+09 | 100.0 | 64.0 | 2222222.22 | 0 | 3200000.0 | 4.188611 |
| 1264 | 1449 | 2021-11-11 12:52:15-05:00 | 0.2 | 855.41 | 1987244032 | 32.0 | 2.296381e+09 | 100.0 | 64.0 | 2222222.22 | 0 | 3200000.0 | 4.191389 |
| 1265 | 1450 | 2021-11-11 12:52:25-05:00 | 0.2 | 827.00 | 1987674112 | 34.0 | 2.296381e+09 | 100.0 | 64.0 | 2222222.22 | 0 | 3200000.0 | 4.194167 |
| 1266 | 1451 | 2021-11-11 12:52:36-05:00 | 0.3 | 946.20 | 1988100096 | 32.0 | 2.296381e+09 | 100.0 | 64.0 | 2222222.22 | 0 | 3200000.0 | 4.197222 |
| 1267 | 1452 | 2021-11-11 12:52:46-05:00 | 0.2 | 1012.97 | 1988833280 | 32.0 | 2.296381e+09 | 100.0 | 67.0 | 2222222.22 | 0 | 3200000.0 | 4.200000 |
| 1268 | 1453 | 2021-11-11 12:52:57-05:00 | 0.7 | 994.19 | 1992646656 | 32.0 | 2.296381e+09 | 100.0 | 71.0 | 2222222.22 | 0 | 3200000.0 | 4.203056 |
| 1269 | 1454 | 2021-11-11 12:53:07-05:00 | 0.3 | 936.49 | 1990811648 | 34.0 | 2.296381e+09 | 100.0 | 67.0 | 2222222.22 | 0 | 3200000.0 | 4.205833 |
| 1270 | 1455 | 2021-11-11 12:53:18-05:00 | 0.3 | 839.48 | 1990594560 | 32.0 | 2.296381e+09 | 100.0 | 67.0 | 2222222.22 | 0 | 3200000.0 | 4.208889 |
| 1271 | 1456 | 2021-11-11 12:53:28-05:00 | 0.3 | 940.45 | 1988472832 | 33.0 | 2.296381e+09 | 100.0 | 66.0 | 2222222.22 | 0 | 3200000.0 | 4.211667 |